Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	10000
Missing cells	3598
Missing cells (%)	1.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 MiB
Average record size in memory	192.0 B

Variable types

Categorical	7
Numeric	17

Alerts

`date_time` has a high cardinality: 10000 distinct values	High cardinality
`srch_ci` has a high cardinality: 967 distinct values	High cardinality
`srch_co` has a high cardinality: 978 distinct values	High cardinality
`site_name` is highly correlated with `posa_continent`	High correlation
`posa_continent` is highly correlated with `site_name`	High correlation
`orig_destination_distance` is highly correlated with `hotel_continent`	High correlation
`srch_destination_id` is highly correlated with `srch_destination_type_id`	High correlation
`srch_destination_type_id` is highly correlated with `srch_destination_id`	High correlation
`hotel_continent` is highly correlated with `orig_destination_distance`	High correlation
`site_name` is highly correlated with `posa_continent`	High correlation
`posa_continent` is highly correlated with `site_name`	High correlation
`srch_adults_cnt` is highly correlated with `srch_rm_cnt`	High correlation
`srch_rm_cnt` is highly correlated with `srch_adults_cnt`	High correlation
`site_name` is highly correlated with `posa_continent`	High correlation
`posa_continent` is highly correlated with `site_name`	High correlation
`site_name` is highly correlated with `posa_continent` and 2 other fields	High correlation
`posa_continent` is highly correlated with `site_name` and 4 other fields	High correlation
`user_location_country` is highly correlated with `site_name` and 2 other fields	High correlation
`user_location_region` is highly correlated with `site_name` and 2 other fields	High correlation
`orig_destination_distance` is highly correlated with `hotel_continent` and 2 other fields	High correlation
`srch_adults_cnt` is highly correlated with `srch_rm_cnt`	High correlation
`srch_rm_cnt` is highly correlated with `srch_adults_cnt`	High correlation
`srch_destination_id` is highly correlated with `srch_destination_type_id`	High correlation
`srch_destination_type_id` is highly correlated with `srch_destination_id`	High correlation
`hotel_continent` is highly correlated with `posa_continent` and 3 other fields	High correlation
`hotel_country` is highly correlated with `posa_continent` and 3 other fields	High correlation
`hotel_market` is highly correlated with `orig_destination_distance` and 2 other fields	High correlation
`orig_destination_distance` has 3582 (35.8%) missing values	Missing
`date_time` is uniformly distributed	Uniform
`date_time` has unique values	Unique
`user_location_region` has 131 (1.3%) zeros	Zeros
`channel` has 1224 (12.2%) zeros	Zeros
`srch_children_cnt` has 7884 (78.8%) zeros	Zeros
`hotel_continent` has 186 (1.9%) zeros	Zeros

Reproduction

Analysis started	2022-09-03 16:38:46.591885
Analysis finished	2022-09-03 16:39:33.833413
Duration	47.24 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

date_time
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

2014-07-03 10:19:15	1
2013-08-04 14:42:43	1
2013-08-14 12:51:29	1
2013-02-24 22:19:54	1
2013-05-06 11:45:39	1
Other values (9995)	9995

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	190000
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10000 ?
Unique (%)	100.0%

Sample

1st row	2014-07-03 10:19:15
2nd row	2014-07-02 18:39:51
3rd row	2013-05-09 09:41:01
4th row	2014-07-30 19:23:01
5th row	2014-07-10 15:14:48

Common Values

Value	Count	Frequency (%)
2014-07-03 10:19:15	1	< 0.1%
2013-08-04 14:42:43	1	< 0.1%
2013-08-14 12:51:29	1	< 0.1%
2013-02-24 22:19:54	1	< 0.1%
2013-05-06 11:45:39	1	< 0.1%
2014-07-10 22:44:41	1	< 0.1%
2013-06-22 17:23:48	1	< 0.1%
2014-07-11 23:06:15	1	< 0.1%
2013-07-08 21:13:42	1	< 0.1%
2014-05-28 11:50:53	1	< 0.1%
Other values (9990)	9990	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-12-09	40	0.2%
2014-12-30	40	0.2%
2014-09-24	39	0.2%
2014-07-21	38	0.2%
2014-12-10	36	0.2%
2014-11-13	35	0.2%
2014-11-05	35	0.2%
2014-07-09	35	0.2%
2014-12-29	35	0.2%
2014-07-16	35	0.2%
Other values (10049)	19632	98.2%

Most occurring characters

Value	Count	Frequency (%)
1	31067	16.4%
0	31063	16.3%
2	24068	12.7%
-	20000	10.5%
:	20000	10.5%
4	14684	7.7%
3	11658	6.1%
	10000	5.3%
5	7747	4.1%
7	5129	2.7%
Other values (3)	14584	7.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	140000	73.7%
Dash Punctuation	20000	10.5%
Other Punctuation	20000	10.5%
Space Separator	10000	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	31067	22.2%
0	31063	22.2%
2	24068	17.2%
4	14684	10.5%
3	11658	8.3%
5	7747	5.5%
7	5129	3.7%
9	4984	3.6%
8	4968	3.5%
6	4632	3.3%

Dash Punctuation

Value	Count	Frequency (%)
-	20000	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	20000	100.0%

Space Separator

Value	Count	Frequency (%)
	10000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	190000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	31067	16.4%
0	31063	16.3%
2	24068	12.7%
-	20000	10.5%
:	20000	10.5%
4	14684	7.7%
3	11658	6.1%
	10000	5.3%
5	7747	4.1%
7	5129	2.7%
Other values (3)	14584	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	190000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	31067	16.4%
0	31063	16.3%
2	24068	12.7%
-	20000	10.5%
:	20000	10.5%
4	14684	7.7%
3	11658	6.1%
	10000	5.3%
5	7747	4.1%
7	5129	2.7%
Other values (3)	14584	7.7%

site_name
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	39
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.9692

Minimum	2
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	2
Q3	17
95-th percentile	37
Maximum	53
Range	51
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	12.06523138
Coefficient of variation (CV)	1.210250711
Kurtosis	-0.06173860975
Mean	9.9692
Median Absolute Deviation (MAD)	0
Skewness	1.210677867
Sum	99692
Variance	145.5698083
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
2	6270	62.7%
11	722	7.2%
24	622	6.2%
37	550	5.5%
34	490	4.9%
23	220	2.2%
8	216	2.2%
13	186	1.9%
17	92	0.9%
28	70	0.7%
Other values (29)	562	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	6270	62.7%
6	2	< 0.1%
7	7	0.1%
8	216	2.2%
9	13	0.1%
10	22	0.2%
11	722	7.2%
13	186	1.9%
14	14	0.1%
15	19	0.2%

Value	Count	Frequency (%)
53	1	< 0.1%
48	6	0.1%
46	3	< 0.1%
45	3	< 0.1%
44	1	< 0.1%
43	1	< 0.1%
40	12	0.1%
37	550	5.5%
36	16	0.2%
35	32	0.3%

posa_continent
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

3	7500
1	1225
2	918
4	286
0	71

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

Most occurring characters

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	7500	75.0%
1	1225	12.2%
2	918	9.2%
4	286	2.9%
0	71	0.7%

user_location_country
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	139
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86.1988

Minimum	0
Maximum	239
Zeros	41
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	66
median	66
Q3	70
95-th percentile	205
Maximum	239
Range	239
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	59.56096397
Coefficient of variation (CV)	0.6909720782
Kurtosis	0.2572150546
Mean	86.1988
Median Absolute Deviation (MAD)	0
Skewness	1.120965135
Sum	861988
Variance	3547.508429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66	5331	53.3%
205	1153	11.5%
3	592	5.9%
69	524	5.2%
1	217	2.2%
77	216	2.2%
46	193	1.9%
215	139	1.4%
133	106	1.1%
23	91	0.9%
Other values (129)	1438	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	41	0.4%
1	217	2.2%
3	592	5.9%
4	1	< 0.1%
5	20	0.2%
6	2	< 0.1%
8	2	< 0.1%
10	1	< 0.1%
11	2	< 0.1%
12	38	0.4%

Value	Count	Frequency (%)
239	1	< 0.1%
235	31	0.3%
233	1	< 0.1%
231	40	0.4%
230	10	0.1%
229	6	0.1%
228	2	< 0.1%
222	4	< 0.1%
221	1	< 0.1%
220	1	< 0.1%

user_location_region
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	493
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	308.8758

Minimum	0
Maximum	1017
Zeros	131
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	38
Q1	174
median	314
Q3	385
95-th percentile	785.1
Maximum	1017
Range	1017
Interquartile range (IQR)	211

Descriptive statistics

Standard deviation	207.9108286
Coefficient of variation (CV)	0.6731211336
Kurtosis	1.515119939
Mean	308.8758
Median Absolute Deviation (MAD)	133
Skewness	1.127841125
Sum	3088758
Variance	43226.91267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
174	1063	10.6%
348	478	4.8%
354	463	4.6%
442	375	3.8%
220	375	3.8%
462	283	2.8%
50	278	2.8%
155	255	2.5%
135	212	2.1%
258	210	2.1%
Other values (483)	6008	60.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	131	1.3%
3	2	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	3	< 0.1%
8	1	< 0.1%
9	9	0.1%
10	2	< 0.1%
11	18	0.2%

Value	Count	Frequency (%)
1017	3	< 0.1%
1016	1	< 0.1%
1011	11	0.1%
1010	5	0.1%
1007	1	< 0.1%
1005	2	< 0.1%
1004	1	< 0.1%
1003	4	< 0.1%
1002	9	0.1%
1001	1	< 0.1%

user_location_city
Real number (ℝ_≥0)

Distinct	3321
Distinct (%)	33.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27498.3059

Minimum	15
Maximum	56507
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	15
5-th percentile	2096
Q1	12802.75
median	26956.5
Q3	42328
95-th percentile	53139
Maximum	56507
Range	56492
Interquartile range (IQR)	29525.25

Descriptive statistics

Standard deviation	16777.10576
Coefficient of variation (CV)	0.6101141583
Kurtosis	-1.253788739
Mean	27498.3059
Median Absolute Deviation (MAD)	14992.5
Skewness	0.02731975892
Sum	274983059
Variance	281471277.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5703	215	2.1%
48862	172	1.7%
24103	124	1.2%
25315	106	1.1%
36086	94	0.9%
14703	79	0.8%
35390	72	0.7%
2086	70	0.7%
4924	70	0.7%
26232	69	0.7%
Other values (3311)	8929	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15	1	< 0.1%
19	1	< 0.1%
40	1	< 0.1%
50	2	< 0.1%
69	1	< 0.1%
76	27	0.3%
104	1	< 0.1%
113	1	< 0.1%
120	5	0.1%
133	1	< 0.1%

Value	Count	Frequency (%)
56507	2	< 0.1%
56472	1	< 0.1%
56440	34	0.3%
56436	2	< 0.1%
56399	4	< 0.1%
56392	3	< 0.1%
56350	1	< 0.1%
56341	1	< 0.1%
56315	1	< 0.1%
56295	1	< 0.1%

orig_destination_distance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6406
Distinct (%)	99.8%
Missing	3582
Missing (%)	35.8%
Infinite	0
Infinite (%)	0.0%
Mean	1958.831814

Minimum	0.0603
Maximum	11478.4059
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.0603
5-th percentile	39.62321
Q1	310.416775
median	1144.79825
Q3	2537.7307
95-th percentile	6758.862065
Maximum	11478.4059
Range	11478.3456
Interquartile range (IQR)	2227.313925

Descriptive statistics

Standard deviation	2227.854817
Coefficient of variation (CV)	1.13733849
Kurtosis	2.291083553
Mean	1958.831814
Median Absolute Deviation (MAD)	953.10285
Skewness	1.626872225
Sum	12571782.58
Variance	4963337.086
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
276.2148	2	< 0.1%
1208.7056	2	< 0.1%
2233.8191	2	< 0.1%
114.2796	2	< 0.1%
1033.3647	2	< 0.1%
560.7545	2	< 0.1%
952.7244	2	< 0.1%
11.6036	2	< 0.1%
946.6702	2	< 0.1%
189.4092	2	< 0.1%
Other values (6396)	6398	64.0%
(Missing)	3582	35.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0603	1	< 0.1%
0.1183	1	< 0.1%
0.1348	1	< 0.1%
0.2033	1	< 0.1%
0.2262	1	< 0.1%
0.24	1	< 0.1%
0.2452	1	< 0.1%
0.2579	1	< 0.1%
0.288	1	< 0.1%
0.3105	1	< 0.1%

Value	Count	Frequency (%)
11478.4059	1	< 0.1%
11440.3257	1	< 0.1%
11411.0035	1	< 0.1%
11372.4873	1	< 0.1%
11225.3117	1	< 0.1%
11152.7921	1	< 0.1%
10951.3521	1	< 0.1%
10599.7575	1	< 0.1%
10549.872	1	< 0.1%
10549.586	1	< 0.1%

user_id
Real number (ℝ_≥0)

Distinct	9866
Distinct (%)	98.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	599553.6947

Minimum	243
Maximum	1198741
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	243
5-th percentile	57371.95
Q1	297793.5
median	596155
Q3	899771
95-th percentile	1143234.2
Maximum	1198741
Range	1198498
Interquartile range (IQR)	601977.5

Descriptive statistics

Standard deviation	348595.4759
Coefficient of variation (CV)	0.5814249482
Kurtosis	-1.20764299
Mean	599553.6947
Median Absolute Deviation (MAD)	300574
Skewness	0.01296501158
Sum	5995536947
Variance	1.215188058 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100317	3	< 0.1%
1088673	3	< 0.1%
105642	2	< 0.1%
1040840	2	< 0.1%
1123993	2	< 0.1%
356214	2	< 0.1%
93889	2	< 0.1%
153009	2	< 0.1%
657055	2	< 0.1%
114941	2	< 0.1%
Other values (9856)	9978	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
243	1	< 0.1%
537	1	< 0.1%
552	1	< 0.1%
561	1	< 0.1%
611	1	< 0.1%
614	1	< 0.1%
726	1	< 0.1%
859	1	< 0.1%
1368	1	< 0.1%
1461	1	< 0.1%

Value	Count	Frequency (%)
1198741	1	< 0.1%
1198735	1	< 0.1%
1198641	1	< 0.1%
1198553	1	< 0.1%
1198425	1	< 0.1%
1198361	1	< 0.1%
1198277	1	< 0.1%
1198134	1	< 0.1%
1198115	1	< 0.1%
1197979	1	< 0.1%

is_mobile
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	8648
1	1352

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

Most occurring characters

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	8648	86.5%
1	1352	13.5%

is_package
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	7497
1	2503

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

Most occurring characters

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7497	75.0%
1	2503	25.0%

channel
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8968

Minimum	0
Maximum	10
Zeros	1224
Zeros (%)	12.2%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	9
95-th percentile	9
Maximum	10
Range	10
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.707603592
Coefficient of variation (CV)	0.6287484045
Kurtosis	-1.521642298
Mean	5.8968
Median Absolute Deviation (MAD)	0
Skewness	-0.5130586795
Sum	58968
Variance	13.74632439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
9	5570	55.7%
0	1224	12.2%
1	1018	10.2%
2	768	7.7%
5	636	6.4%
3	424	4.2%
4	237	2.4%
7	76	0.8%
8	33	0.3%
6	13	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1224	12.2%
1	1018	10.2%
2	768	7.7%
3	424	4.2%
4	237	2.4%
5	636	6.4%
6	13	0.1%
7	76	0.8%
8	33	0.3%
9	5570	55.7%

Value	Count	Frequency (%)
10	1	< 0.1%
9	5570	55.7%
8	33	0.3%
7	76	0.8%
6	13	0.1%
5	636	6.4%
4	237	2.4%
3	424	4.2%
2	768	7.7%
1	1018	10.2%

srch_ci
Categorical

HIGH CARDINALITY

Distinct	967
Distinct (%)	9.7%
Missing	8
Missing (%)	0.1%
Memory size	78.2 KiB

2014-12-26	69
2014-12-25	56
2014-12-27	49
2014-12-30	49
2014-12-28	49
Other values (962)	9720

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	99920
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	81 ?
Unique (%)	0.8%

Sample

1st row	2014-08-12
2nd row	2014-08-17
3rd row	2013-05-09
4th row	2014-08-11
5th row	2014-08-07

Common Values

Value	Count	Frequency (%)
2014-12-26	69	0.7%
2014-12-25	56	0.6%
2014-12-27	49	0.5%
2014-12-30	49	0.5%
2014-12-28	49	0.5%
2014-12-31	46	0.5%
2014-08-30	42	0.4%
2014-12-20	41	0.4%
2014-08-29	39	0.4%
2014-12-19	38	0.4%
Other values (957)	9514	95.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2014-12-26	69	0.7%
2014-12-25	56	0.6%
2014-12-27	49	0.5%
2014-12-30	49	0.5%
2014-12-28	49	0.5%
2014-12-31	46	0.5%
2014-08-30	42	0.4%
2014-12-20	41	0.4%
2014-08-29	39	0.4%
2014-12-19	38	0.4%
Other values (957)	9514	95.2%

Most occurring characters

Value	Count	Frequency (%)
0	21720	21.7%
-	19984	20.0%
1	18789	18.8%
2	16130	16.1%
4	7778	7.8%
3	4934	4.9%
5	2906	2.9%
8	2100	2.1%
7	1953	2.0%
9	1836	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79936	80.0%
Dash Punctuation	19984	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	21720	27.2%
1	18789	23.5%
2	16130	20.2%
4	7778	9.7%
3	4934	6.2%
5	2906	3.6%
8	2100	2.6%
7	1953	2.4%
9	1836	2.3%
6	1790	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	19984	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99920	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	21720	21.7%
-	19984	20.0%
1	18789	18.8%
2	16130	16.1%
4	7778	7.8%
3	4934	4.9%
5	2906	2.9%
8	2100	2.1%
7	1953	2.0%
9	1836	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	21720	21.7%
-	19984	20.0%
1	18789	18.8%
2	16130	16.1%
4	7778	7.8%
3	4934	4.9%
5	2906	2.9%
8	2100	2.1%
7	1953	2.0%
9	1836	1.8%

srch_co
Categorical

HIGH CARDINALITY

Distinct	978
Distinct (%)	9.8%
Missing	8
Missing (%)	0.1%
Memory size	78.2 KiB

2015-01-01	60
2015-01-03	57
2014-12-28	55
2015-01-02	54
2014-12-29	53
Other values (973)	9713

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	99920
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	94 ?
Unique (%)	0.9%

Sample

1st row	2014-08-13
2nd row	2014-08-21
3rd row	2013-05-10
4th row	2014-08-13
5th row	2014-08-08

Common Values

Value	Count	Frequency (%)
2015-01-01	60	0.6%
2015-01-03	57	0.6%
2014-12-28	55	0.5%
2015-01-02	54	0.5%
2014-12-29	53	0.5%
2015-01-04	46	0.5%
2014-12-27	45	0.4%
2014-09-14	44	0.4%
2014-08-31	43	0.4%
2014-12-26	41	0.4%
Other values (968)	9494	94.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-01-01	60	0.6%
2015-01-03	57	0.6%
2014-12-28	55	0.6%
2015-01-02	54	0.5%
2014-12-29	53	0.5%
2015-01-04	46	0.5%
2014-12-27	45	0.5%
2014-09-14	44	0.4%
2014-08-31	43	0.4%
2014-12-26	41	0.4%
Other values (968)	9494	95.0%

Most occurring characters

Value	Count	Frequency (%)
0	22046	22.1%
-	19984	20.0%
1	18743	18.8%
2	15867	15.9%
4	7713	7.7%
3	4795	4.8%
5	3049	3.1%
8	2103	2.1%
7	1929	1.9%
9	1928	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79936	80.0%
Dash Punctuation	19984	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	22046	27.6%
1	18743	23.4%
2	15867	19.8%
4	7713	9.6%
3	4795	6.0%
5	3049	3.8%
8	2103	2.6%
7	1929	2.4%
9	1928	2.4%
6	1763	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	19984	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99920	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	22046	22.1%
-	19984	20.0%
1	18743	18.8%
2	15867	15.9%
4	7713	7.7%
3	4795	4.8%
5	3049	3.1%
8	2103	2.1%
7	1929	1.9%
9	1928	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99920	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	22046	22.1%
-	19984	20.0%
1	18743	18.8%
2	15867	15.9%
4	7713	7.7%
3	4795	4.8%
5	3049	3.1%
8	2103	2.1%
7	1929	1.9%
9	1928	1.9%

srch_adults_cnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0292

Minimum	0
Maximum	9
Zeros	27
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9217550234
Coefficient of variation (CV)	0.454245527
Kurtosis	8.924681825
Mean	2.0292
Median Absolute Deviation (MAD)	0
Skewness	2.258161018
Sum	20292
Variance	0.8496323232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	6527	65.3%
1	2136	21.4%
3	551	5.5%
4	547	5.5%
6	95	0.9%
5	80	0.8%
8	28	0.3%
0	27	0.3%
7	7	0.1%
9	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27	0.3%
1	2136	21.4%
2	6527	65.3%
3	551	5.5%
4	547	5.5%
5	80	0.8%
6	95	0.9%
7	7	0.1%
8	28	0.3%
9	2	< 0.1%

Value	Count	Frequency (%)
9	2	< 0.1%
8	28	0.3%
7	7	0.1%
6	95	0.9%
5	80	0.8%
4	547	5.5%
3	551	5.5%
2	6527	65.3%
1	2136	21.4%
0	27	0.3%

srch_children_cnt
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3341

Minimum	0
Maximum	6
Zeros	7884
Zeros (%)	78.8%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7278256405
Coefficient of variation (CV)	2.178466449
Kurtosis	6.234488353
Mean	0.3341
Median Absolute Deviation (MAD)	0
Skewness	2.40951153
Sum	3341
Variance	0.529730163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	7884	78.8%
1	1128	11.3%
2	811	8.1%
3	128	1.3%
4	41	0.4%
5	5	0.1%
6	3	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7884	78.8%
1	1128	11.3%
2	811	8.1%
3	128	1.3%
4	41	0.4%
5	5	0.1%
6	3	< 0.1%

Value	Count	Frequency (%)
6	3	< 0.1%
5	5	0.1%
4	41	0.4%
3	128	1.3%
2	811	8.1%
1	1128	11.3%
0	7884	78.8%

srch_rm_cnt
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1157

Minimum	0
Maximum	8
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	8
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4683326206
Coefficient of variation (CV)	0.4197657261
Kurtosis	69.34542885
Mean	1.1157
Median Absolute Deviation (MAD)	0
Skewness	6.861619633
Sum	11157
Variance	0.2193354435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	9150	91.5%
2	673	6.7%
3	116	1.2%
4	25	0.2%
5	18	0.2%
8	10	0.1%
6	6	0.1%
0	1	< 0.1%
7	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	9150	91.5%
2	673	6.7%
3	116	1.2%
4	25	0.2%
5	18	0.2%
6	6	0.1%
7	1	< 0.1%
8	10	0.1%

Value	Count	Frequency (%)
8	10	0.1%
7	1	< 0.1%
6	6	0.1%
5	18	0.2%
4	25	0.2%
3	116	1.2%
2	673	6.7%
1	9150	91.5%
0	1	< 0.1%

srch_destination_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	2571
Distinct (%)	25.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14524.2294

Minimum	8
Maximum	64940
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	8
5-th percentile	1612.1
Q1	8266
median	9147
Q3	19257.25
95-th percentile	42630
Maximum	64940
Range	64932
Interquartile range (IQR)	10991.25

Descriptive statistics

Standard deviation	11164.01188
Coefficient of variation (CV)	0.7686474489
Kurtosis	3.861588013
Mean	14524.2294
Median Absolute Deviation (MAD)	2861.5
Skewness	1.896025874
Sum	145242294
Variance	124635161.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8250	344	3.4%
8267	265	2.6%
8791	177	1.8%
8268	141	1.4%
8253	138	1.4%
8745	122	1.2%
8260	100	1.0%
8254	98	1.0%
11439	93	0.9%
8279	90	0.9%
Other values (2561)	8432	84.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	< 0.1%
19	1	< 0.1%
21	2	< 0.1%
24	1	< 0.1%
25	3	< 0.1%
27	2	< 0.1%
33	1	< 0.1%
40	1	< 0.1%
43	2	< 0.1%
59	1	< 0.1%

Value	Count	Frequency (%)
64940	1	< 0.1%
64778	1	< 0.1%
64627	1	< 0.1%
64623	1	< 0.1%
64595	1	< 0.1%
64292	1	< 0.1%
63950	2	< 0.1%
63894	1	< 0.1%
63687	2	< 0.1%
63642	1	< 0.1%

srch_destination_type_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5915

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	6
Maximum	8
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.157659218
Coefficient of variation (CV)	0.8325908615
Kurtosis	-1.174449517
Mean	2.5915
Median Absolute Deviation (MAD)	0
Skewness	0.7812028658
Sum	25915
Variance	4.655493299
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	6168	61.7%
6	2256	22.6%
3	733	7.3%
5	478	4.8%
4	324	3.2%
8	39	0.4%
7	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6168	61.7%
3	733	7.3%
4	324	3.2%
5	478	4.8%
6	2256	22.6%
7	2	< 0.1%
8	39	0.4%

Value	Count	Frequency (%)
8	39	0.4%
7	2	< 0.1%
6	2256	22.6%
5	478	4.8%
4	324	3.2%
3	733	7.3%
1	6168	61.7%

is_booking
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

0	9259
1	741

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

Most occurring characters

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9259	92.6%
1	741	7.4%

cnt
Real number (ℝ_≥0)

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4943

Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	4
Maximum	39
Range	38
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.260922877
Coefficient of variation (CV)	0.8438217743
Kurtosis	146.6650986
Mean	1.4943
Median Absolute Deviation (MAD)	0
Skewness	7.930282349
Sum	14943
Variance	1.589926503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	7391	73.9%
2	1549	15.5%
3	557	5.6%
4	222	2.2%
5	128	1.3%
6	55	0.5%
7	35	0.4%
8	27	0.3%
9	11	0.1%
10	7	0.1%
Other values (9)	18	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7391	73.9%
2	1549	15.5%
3	557	5.6%
4	222	2.2%
5	128	1.3%
6	55	0.5%
7	35	0.4%
8	27	0.3%
9	11	0.1%
10	7	0.1%

Value	Count	Frequency (%)
39	1	< 0.1%
34	1	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
16	4	< 0.1%
14	1	< 0.1%
13	3	< 0.1%
12	2	< 0.1%
11	4	< 0.1%
10	7	0.1%

hotel_continent
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1641

Minimum	0
Maximum	6
Zeros	186
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	2
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.629121418
Coefficient of variation (CV)	0.5148767162
Kurtosis	-0.7073179295
Mean	3.1641
Median Absolute Deviation (MAD)	0
Skewness	0.7745211142
Sum	31641
Variance	2.654036594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	5261	52.6%
6	2029	20.3%
3	1270	12.7%
4	1135	11.3%
0	186	1.9%
5	119	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	186	1.9%
2	5261	52.6%
3	1270	12.7%
4	1135	11.3%
5	119	1.2%
6	2029	20.3%

Value	Count	Frequency (%)
6	2029	20.3%
5	119	1.2%
4	1135	11.3%
3	1270	12.7%
2	5261	52.6%
0	186	1.9%

hotel_country
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	133
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.9076

Minimum	0
Maximum	208
Zeros	25
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	50
median	50
Q3	105
95-th percentile	198
Maximum	208
Range	208
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	56.28936411
Coefficient of variation (CV)	0.6957240618
Kurtosis	-0.1373187037
Mean	80.9076
Median Absolute Deviation (MAD)	3
Skewness	1.049365285
Sum	809076
Variance	3168.492511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	4789	47.9%
8	503	5.0%
198	472	4.7%
105	344	3.4%
70	321	3.2%
204	296	3.0%
77	260	2.6%
182	220	2.2%
106	158	1.6%
144	145	1.5%
Other values (123)	2492	24.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25	0.2%
1	4	< 0.1%
3	3	< 0.1%
4	3	< 0.1%
5	80	0.8%
7	24	0.2%
8	503	5.0%
9	4	< 0.1%
10	1	< 0.1%
11	9	0.1%

Value	Count	Frequency (%)
208	76	0.8%
206	1	< 0.1%
205	1	< 0.1%
204	296	3.0%
203	26	0.3%
202	5	0.1%
200	9	0.1%
199	17	0.2%
198	472	4.7%
196	45	0.4%

hotel_market
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1108
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	595.8479

Minimum	2
Maximum	2113
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2
5-th percentile	19
Q1	155
median	585
Q3	701
95-th percentile	1614
Maximum	2113
Range	2111
Interquartile range (IQR)	546

Descriptive statistics

Standard deviation	508.7806767
Coefficient of variation (CV)	0.853876764
Kurtosis	0.1998705827
Mean	595.8479
Median Absolute Deviation (MAD)	360
Skewness	0.972189318
Sum	5958479
Variance	258857.7769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
628	458	4.6%
675	431	4.3%
365	228	2.3%
682	228	2.3%
701	224	2.2%
19	221	2.2%
110	211	2.1%
27	172	1.7%
368	135	1.4%
212	128	1.3%
Other values (1098)	7564	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	98	1.0%
3	3	< 0.1%
4	44	0.4%
5	17	0.2%
6	8	0.1%
7	9	0.1%
8	18	0.2%
9	2	< 0.1%
10	22	0.2%
11	6	0.1%

Value	Count	Frequency (%)
2113	1	< 0.1%
2111	5	0.1%
2107	1	< 0.1%
2104	2	< 0.1%
2103	2	< 0.1%
2100	1	< 0.1%
2099	1	< 0.1%
2097	1	< 0.1%
2092	3	< 0.1%
2090	1	< 0.1%

hotel_cluster
Real number (ℝ_≥0)

Distinct	100
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.0406

Minimum	0
Maximum	99
Zeros	94
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	26
median	50
Q3	73
95-th percentile	96
Maximum	99
Range	99
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	28.69762546
Coefficient of variation (CV)	0.5734868379
Kurtosis	-1.125432989
Mean	50.0406
Median Absolute Deviation (MAD)	23
Skewness	0.00430155984
Sum	500406
Variance	823.553707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
91	276	2.8%
41	212	2.1%
48	191	1.9%
64	185	1.8%
65	177	1.8%
5	173	1.7%
83	169	1.7%
98	161	1.6%
21	153	1.5%
50	152	1.5%
Other values (90)	8151	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.9%
1	95	0.9%
2	91	0.9%
3	69	0.7%
4	92	0.9%
5	173	1.7%
6	103	1.0%
7	78	0.8%
8	95	0.9%
9	132	1.3%

Value	Count	Frequency (%)
99	141	1.4%
98	161	1.6%
97	139	1.4%
96	104	1.0%
95	121	1.2%
94	75	0.8%
93	36	0.4%
92	53	0.5%
91	276	2.8%
90	95	0.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	date_time	site_name	posa_continent	user_location_country	user_location_region	user_location_city	orig_destination_distance	user_id	is_mobile	is_package	channel	srch_ci	srch_co	srch_adults_cnt	srch_children_cnt	srch_rm_cnt	srch_destination_id	srch_destination_type_id	is_booking	cnt	hotel_continent	hotel_country	hotel_market	hotel_cluster
0	2014-07-03 10:19:15	34	3	205	354	273	1525.9514	1046539	0	0	9	2014-08-12	2014-08-13	4	0	2	42604	1	0	3	2	50	673	72
1	2014-07-02 18:39:51	34	3	205	339	21141	1332.2945	304970	1	0	5	2014-08-17	2014-08-21	2	0	1	17494	1	1	1	2	50	425	91
2	2013-05-09 09:41:01	33	2	66	442	35390	17.0879	1186531	0	0	9	2013-05-09	2013-05-10	1	0	1	12556	5	0	2	2	50	409	16
3	2014-07-30 19:23:01	2	3	66	442	12416	1990.1419	289806	0	0	9	2014-08-11	2014-08-13	2	1	1	8854	1	0	1	2	198	402	74
4	2014-07-10 15:14:48	25	2	198	153	17956	NaN	865357	0	0	9	2014-08-07	2014-08-08	2	0	1	23048	1	0	1	3	48	152	16
5	2013-09-07 18:28:49	2	3	66	442	46296	1206.3054	1122122	1	1	9	2013-10-17	2013-10-19	2	0	1	8254	1	0	1	2	50	365	17
6	2013-07-12 11:30:40	2	3	66	220	10345	NaN	396769	0	1	9	2013-07-14	2013-07-16	1	0	1	8250	1	0	1	2	50	628	49
7	2013-08-28 03:52:04	2	3	235	13	53632	NaN	539773	0	0	9	2013-09-02	2013-09-05	1	0	1	21486	6	0	1	6	200	996	38
8	2013-02-06 14:44:53	2	3	66	348	48862	5008.8904	1131847	0	0	9	2013-03-16	2013-03-20	2	0	1	8857	1	0	1	2	50	214	28
9	2014-04-06 05:59:13	2	3	66	294	7976	1397.3395	42617	1	1	9	2014-06-04	2014-06-09	3	0	1	12206	6	0	2	2	50	628	18

Last rows

	date_time	site_name	posa_continent	user_location_country	user_location_region	user_location_city	orig_destination_distance	user_id	is_mobile	is_package	channel	srch_ci	srch_co	srch_adults_cnt	srch_children_cnt	srch_rm_cnt	srch_destination_id	srch_destination_type_id	is_booking	cnt	hotel_continent	hotel_country	hotel_market	hotel_cluster
9990	2014-12-11 08:27:38	2	3	66	220	775	5119.0050	10897	0	1	0	2014-12-19	2014-12-26	2	2	1	18488	6	0	1	6	105	29	81
9991	2014-07-12 10:44:18	24	2	3	79	11049	NaN	466816	0	0	5	2014-08-10	2014-08-11	1	0	1	8741	1	0	1	6	144	13	37
9992	2014-12-25 10:30:59	2	3	66	260	24757	985.8115	763518	0	0	0	2015-02-12	2015-02-15	2	0	1	12261	6	0	1	2	50	412	91
9993	2014-12-31 07:02:28	2	3	66	254	3529	1096.9660	402592	0	0	2	2015-04-16	2015-04-19	2	0	1	12206	6	0	1	2	50	628	79
9994	2013-11-29 17:28:28	2	3	19	38	47318	NaN	358718	0	0	9	2013-12-30	2014-01-03	1	0	1	8287	1	0	2	2	198	397	6
9995	2014-10-16 01:07:25	2	3	12	921	26044	NaN	438500	0	1	1	2014-10-17	2014-10-22	2	0	1	1119	3	0	1	4	137	2092	62
9996	2013-06-01 20:42:07	2	3	66	311	24240	NaN	367734	1	0	0	2013-06-08	2013-06-10	2	0	1	14099	4	1	1	2	50	637	95
9997	2013-03-02 10:21:52	34	3	205	135	27655	1169.2600	324902	1	0	9	2013-03-12	2013-03-18	2	0	1	12269	6	0	1	2	50	1230	41
9998	2013-06-12 08:58:44	24	2	3	50	22013	NaN	681544	0	0	9	2013-07-12	2013-07-16	1	0	1	8808	1	0	1	6	169	28	82
9999	2013-12-09 17:07:56	2	3	57	342	5021	NaN	1036099	0	1	9	2014-03-28	2014-04-01	2	0	1	8268	1	0	2	2	50	682	77

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks